﻿USE demo
GO

/****** Object:  Table [dbo].[Base_DealerInfo]    Script Date: 2018/7/27 12:33:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Base_DealerInfo](
	[DealerId] [nvarchar](50) NOT NULL CONSTRAINT [DF_Base_DealerInfo_DealerId]  DEFAULT (newid()),
	[ParentId] [nvarchar](50) NULL CONSTRAINT [DF_Base_DealerInfo_ParentId]  DEFAULT ('0'),
	[Category] [nvarchar](50) NULL,
	[EnCode] [nvarchar](50) NULL,
	[FullName] [nvarchar](100) NULL,
	[ShortName] [nvarchar](100) NULL,
	[SupplierId] [nvarchar](50) NULL,
	[SaleId] [nvarchar](50) NULL,
	[AreaLayer] [int] NULL,
	[PromotionType] [int] NULL,
	[BusinessLicenseImg] [nvarchar](500) NULL,
	[FrontImg] [nvarchar](500) NULL,
	[InsideImg] [nvarchar](500) NULL,
	[SpecialAreaImg] [nvarchar](500) NULL,
	[SpecialAreaAmount] [int] NULL,
	[HandDrawingImg] [nvarchar](500) NULL,
	[CounterAmount] [int] NULL,
	[BackVeneer_36] [int] NULL,
	[BackVeneer_48] [int] NULL,
	[BackVeneer_64] [int] NULL,
	[BackVeneerOther] [int] NULL,
	[UxtId] [nvarchar](50) NULL,
	[UxtName] [nvarchar](100) NULL,
	[IsChain] [int] NULL,
	[IsMain] [int] NULL CONSTRAINT [DF_Base_DealerInfo_IsMain]  DEFAULT ((0)),
	[LinkMan] [nvarchar](50) NULL,
	[LinkTel] [nvarchar](50) NULL,
	[ConsigneeMan] [nvarchar](50) NULL,
	[ConsigneeTel] [nvarchar](50) NULL,
	[ConsigneeAddress] [nvarchar](200) NULL,
	[Location] [nvarchar](50) NULL,
	[LocationLat] [decimal](18, 6) NULL,
	[LocationLng] [decimal](18, 6) NULL,
	[GuideAmount] [int] NULL,
	[SortCode] [int] NULL,
	[DeleteMark] [int] NULL,
	[EnabledMark] [int] NULL,
	[ObjectType] [int] NULL,
	[ObjectTime] [datetime] NULL,
	[Description] [nvarchar](200) NULL,
	[CreateDate] [datetime] NULL,
	[CreateUserId] [nvarchar](50) NULL,
	[CreateUserName] [nvarchar](50) NULL,
	[ModifyDate] [datetime] NULL,
	[ModifyUserId] [nvarchar](50) NULL,
	[ModifyUserName] [nvarchar](50) NULL,
 CONSTRAINT [PK_Base_DealerInfo] PRIMARY KEY CLUSTERED 
(
	[DealerId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'门店ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'DealerId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父级id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'ParentId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户分类' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'Category'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'门店编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'EnCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'门店名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'FullName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'门店简称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'ShortName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'供方ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'SupplierId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'销方ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'SaleId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区域级别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'AreaLayer'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'促销类型 0-无促 1-有促 2-反聘' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'PromotionType'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'营业执照图片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'BusinessLicenseImg'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'门头照片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'FrontImg'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'店内照片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'InsideImg'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专区图片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'SpecialAreaImg'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专区数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'SpecialAreaAmount'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手工平面图' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'HandDrawingImg'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'柜台数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'CounterAmount'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'背板 3.6米数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'BackVeneer_36'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'背板 4.8米数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'BackVeneer_48'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'背板 6.4米数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'BackVeneer_64'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'背板非标数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'BackVeneerOther'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应优信通ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'UxtId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应优信通ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'UxtName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否连锁' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'IsChain'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否总店' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'IsMain'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'LinkMan'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'LinkTel'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'收货人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'ConsigneeMan'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'收货人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'ConsigneeTel'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'收货人地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'ConsigneeAddress'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'经纬度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'Location'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'纬度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'LocationLat'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'经度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'LocationLng'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'导购数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'GuideAmount'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'SortCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'DeleteMark'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效标志 0 关店1正常 2撤店' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'EnabledMark'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录 关店闭店类型: 1 新增 2 关店 3 撤店' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'ObjectType'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录时间 关店闭店类型: 1 新增 2 关店 3 撤店 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'ObjectTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'Description'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'CreateUserId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'CreateUserName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'ModifyUserId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo', @level2type=N'COLUMN',@level2name=N'ModifyUserName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'经销商档案表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DealerInfo'
GO


CREATE TABLE [dbo].[Base_User](
	[UserId] [nvarchar](50) NOT NULL,
	[EnCode] [nvarchar](50) NULL,
	[Account] [nvarchar](50) NULL,
	[Password] [nvarchar](50) NULL,
	[Secretkey] [nvarchar](50) NULL,
	[RealName] [nvarchar](50) NULL,
	[HeadIcon] [nvarchar](200) NULL,
	[SimpleSpelling] [nvarchar](200) NULL,
	[OrganizeId] [nvarchar](50) NULL,
	[DepartmentId] [nvarchar](50) NULL,
	[RoleId] [nvarchar](50) NULL,
	[DutyId] [nvarchar](50) NULL,
	[DutyName] [nvarchar](50) NULL,
	[ObjectId] [nvarchar](50) NULL,
	[DealerId] [nvarchar](50) NULL,
	[UxtId] [nvarchar](50) NULL,
	[UxtName] [nvarchar](50) NULL,
	[UserOnLine] [int] NULL,
	[CheckOnLine] [int] NULL,
	[PreviousVisit] [datetime] NULL,
	[LastVisit] [datetime] NULL,
	[LogOnCount] [int] NULL,
	[SortCode] [int] NULL,
	[DeleteMark] [int] NULL,
	[InnerEmployee] [int] NULL,
	[EnabledMark] [int] NULL,
	[Description] [nvarchar](200) NULL,
	[CreateDate] [datetime] NULL,
	[CreateUserId] [nvarchar](50) NULL,
	[CreateUserName] [nvarchar](50) NULL,
	[ModifyDate] [datetime] NULL,
	[ModifyUserId] [nvarchar](50) NULL,
	[ModifyUserName] [nvarchar](50) NULL,
 CONSTRAINT [PK_Base_User_1] PRIMARY KEY CLUSTERED 
(
	[UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'UserId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'EnCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录账户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Account'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Password'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码秘钥' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Secretkey'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'真实姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'RealName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'头像' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'HeadIcon'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'简拼' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'SimpleSpelling'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'机构主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'OrganizeId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'DepartmentId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'RoleId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'岗位主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'DutyId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'岗位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'DutyName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'供销ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'ObjectId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'门店ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'DealerId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应优信通ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'UxtId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应优信通ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'UxtName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'在线状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'UserOnLine'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'允许多用户同时登录' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'CheckOnLine'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上一次访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'PreviousVisit'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'LastVisit'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'LogOnCount'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'SortCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'DeleteMark'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内部员工' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'InnerEmployee'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'EnabledMark'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Description'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'CreateUserId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'CreateUserName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'ModifyUserId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'ModifyUserName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User'
GO


